Type
Choose the index type: Nonclustered, Clustered, XML or Spatial
Unique
A unique index is one in which no two rows are permitted to have the same index key value.
Table/View
Choose to create a table index or a view index.
Table Name or View Name
Select a table or a view.
Fields
Select the column or columns on which the index is based and the sorting order.
Included Columns
Select the non-key columns to be added to the leaf level of the nonclustered index.
Note: Support from SQL Server 2005 or later and SQL Azure.